Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 343297 |
| Missing cells | 12 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 34.0 MiB |
| Average record size in memory | 104.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 4 |
DATA_AQUISICAO has a high cardinality: 1956 distinct values | High cardinality |
DIAS_ATIVO is highly overall correlated with MESES_ATIVO and 3 other fields | High correlation |
MESES_ATIVO is highly overall correlated with DIAS_ATIVO and 3 other fields | High correlation |
QT_PC_PAGAS is highly overall correlated with DIAS_ATIVO and 4 other fields | High correlation |
QT_PC_VENCIDAS is highly overall correlated with DIAS_ATIVO and 4 other fields | High correlation |
QT_PC_PAGA_EM_DIA is highly overall correlated with QT_PC_PAGAS and 2 other fields | High correlation |
VALOR_PARCELAS_ATRASO is highly overall correlated with DIAS_ATIVO and 4 other fields | High correlation |
PRAZO_FINANCIAMENTO is highly overall correlated with VALOR_TABELA and 1 other fields | High correlation |
VALOR_TABELA is highly overall correlated with PRAZO_FINANCIAMENTO and 1 other fields | High correlation |
PRODUTO is highly overall correlated with PRAZO_FINANCIAMENTO and 1 other fields | High correlation |
QT_PC_VENCIDAS has 241626 (70.4%) zeros | Zeros |
QT_PC_PAGA_ATRASO has 218566 (63.7%) zeros | Zeros |
QT_PC_PAGA_EM_DIA has 3716 (1.1%) zeros | Zeros |
VALOR_PARCELAS_ATRASO has 241626 (70.4%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-10 18:33:43.203677 |
|---|---|
| Analysis finished | 2023-05-10 18:35:34.978885 |
| Duration | 1 minute and 51.78 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
ID_CLIENTE
Real number (ℝ)
| Distinct | 342336 |
|---|---|
| Distinct (%) | 99.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1091769 × 108 |
| Minimum | 2906 |
|---|---|
| Maximum | 5.7111888 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 2906 |
|---|---|
| 5-th percentile | 418399.6 |
| Q1 | 599957 |
| median | 1935123 |
| Q3 | 29910640 |
| 95-th percentile | 5.7109624 × 108 |
| Maximum | 5.7111888 × 108 |
| Range | 5.7111597 × 108 |
| Interquartile range (IQR) | 29310683 |
Descriptive statistics
| Standard deviation | 2.17307 × 108 |
|---|---|
| Coefficient of variation (CV) | 1.9591735 |
| Kurtosis | 0.7015929 |
| Mean | 1.1091769 × 108 |
| Median Absolute Deviation (MAD) | 1466538 |
| Skewness | 1.6384652 |
| Sum | 3.807771 × 1013 |
| Variance | 4.7222333 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 495783 | 2 | < 0.1% |
| 515146 | 2 | < 0.1% |
| 513827 | 2 | < 0.1% |
| 516007 | 2 | < 0.1% |
| 493418 | 2 | < 0.1% |
| 495820 | 2 | < 0.1% |
| 504634 | 2 | < 0.1% |
| 504368 | 2 | < 0.1% |
| 456650 | 2 | < 0.1% |
| 513596 | 2 | < 0.1% |
| Other values (342326) | 343277 |
| Value | Count | Frequency (%) |
| 2906 | 1 | |
| 3358 | 1 | |
| 3392 | 1 | |
| 3411 | 1 | |
| 3453 | 1 | |
| 5730 | 1 | |
| 11921 | 1 | |
| 12539 | 1 | |
| 13124 | 1 | |
| 14352 | 1 |
| Value | Count | Frequency (%) |
| 571118875 | 1 | |
| 571118873 | 1 | |
| 571118855 | 1 | |
| 571118854 | 1 | |
| 571118853 | 1 | |
| 571118852 | 1 | |
| 571118850 | 1 | |
| 571118842 | 1 | |
| 571118841 | 1 | |
| 571118839 | 1 |
DATA_AQUISICAO
Categorical
| Distinct | 1956 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| 30/11/2020 | 1274 |
|---|---|
| 31/07/2020 | 1208 |
| 30/09/2019 | 1203 |
| 31/10/2019 | 1201 |
| 02/09/2019 | 1188 |
| Other values (1951) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 3432970 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 113 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 18/06/2021 |
|---|---|
| 2nd row | 10/04/2018 |
| 3rd row | 09/10/2020 |
| 4th row | 25/06/2019 |
| 5th row | 19/09/2019 |
Common Values
| Value | Count | Frequency (%) |
| 30/11/2020 | 1274 | 0.4% |
| 31/07/2020 | 1208 | 0.4% |
| 30/09/2019 | 1203 | 0.4% |
| 31/10/2019 | 1201 | 0.3% |
| 02/09/2019 | 1188 | 0.3% |
| 01/03/2021 | 1113 | 0.3% |
| 14/03/2018 | 1091 | 0.3% |
| 29/10/2019 | 1013 | 0.3% |
| 31/03/2021 | 942 | 0.3% |
| 03/10/2018 | 930 | 0.3% |
| Other values (1946) | 332134 |
Length
| Value | Count | Frequency (%) |
| 30/11/2020 | 1274 | 0.4% |
| 31/07/2020 | 1208 | 0.4% |
| 30/09/2019 | 1203 | 0.4% |
| 31/10/2019 | 1201 | 0.3% |
| 02/09/2019 | 1188 | 0.3% |
| 01/03/2021 | 1113 | 0.3% |
| 14/03/2018 | 1091 | 0.3% |
| 29/10/2019 | 1013 | 0.3% |
| 31/03/2021 | 942 | 0.3% |
| 03/10/2018 | 930 | 0.3% |
| Other values (1946) | 332134 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 868538 | |
| / | 686594 | |
| 2 | 680312 | |
| 1 | 544970 | |
| 9 | 150507 | 4.4% |
| 8 | 135974 | 4.0% |
| 3 | 91015 | 2.7% |
| 5 | 76495 | 2.2% |
| 6 | 74063 | 2.2% |
| 7 | 65621 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2746376 | |
| Other Punctuation | 686594 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 868538 | |
| 2 | 680312 | |
| 1 | 544970 | |
| 9 | 150507 | 5.5% |
| 8 | 135974 | 5.0% |
| 3 | 91015 | 3.3% |
| 5 | 76495 | 2.8% |
| 6 | 74063 | 2.7% |
| 7 | 65621 | 2.4% |
| 4 | 58881 | 2.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 686594 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3432970 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 868538 | |
| / | 686594 | |
| 2 | 680312 | |
| 1 | 544970 | |
| 9 | 150507 | 4.4% |
| 8 | 135974 | 4.0% |
| 3 | 91015 | 2.7% |
| 5 | 76495 | 2.2% |
| 6 | 74063 | 2.2% |
| 7 | 65621 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3432970 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 868538 | |
| / | 686594 | |
| 2 | 680312 | |
| 1 | 544970 | |
| 9 | 150507 | 4.4% |
| 8 | 135974 | 4.0% |
| 3 | 91015 | 2.7% |
| 5 | 76495 | 2.2% |
| 6 | 74063 | 2.2% |
| 7 | 65621 | 1.9% |
DIAS_ATIVO
Real number (ℝ)
| Distinct | 1050 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 520.94136 |
| Minimum | 22 |
|---|---|
| Maximum | 1296 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 22 |
|---|---|
| 5-th percentile | 70 |
| Q1 | 170 |
| median | 405 |
| Q3 | 841 |
| 95-th percentile | 1204 |
| Maximum | 1296 |
| Range | 1274 |
| Interquartile range (IQR) | 671 |
Descriptive statistics
| Standard deviation | 379.75291 |
|---|---|
| Coefficient of variation (CV) | 0.72897439 |
| Kurtosis | -1.1289618 |
| Mean | 520.94136 |
| Median Absolute Deviation (MAD) | 254 |
| Skewness | 0.49550853 |
| Sum | 1.788376 × 108 |
| Variance | 144212.27 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 161 | 3346 | 1.0% |
| 168 | 3270 | 1.0% |
| 175 | 3240 | 0.9% |
| 169 | 2858 | 0.8% |
| 174 | 2729 | 0.8% |
| 167 | 2678 | 0.8% |
| 162 | 2605 | 0.8% |
| 176 | 2547 | 0.7% |
| 173 | 2370 | 0.7% |
| 153 | 2347 | 0.7% |
| Other values (1040) | 315307 |
| Value | Count | Frequency (%) |
| 22 | 673 | |
| 23 | 536 | |
| 24 | 1 | < 0.1% |
| 25 | 5 | < 0.1% |
| 26 | 577 | |
| 27 | 311 | |
| 28 | 622 | |
| 29 | 522 | |
| 30 | 508 | |
| 33 | 442 |
| Value | Count | Frequency (%) |
| 1296 | 642 | |
| 1295 | 205 | 0.1% |
| 1294 | 363 | |
| 1293 | 165 | < 0.1% |
| 1292 | 6 | < 0.1% |
| 1290 | 318 | |
| 1289 | 210 | 0.1% |
| 1288 | 243 | 0.1% |
| 1287 | 217 | 0.1% |
| 1286 | 257 |
MESES_ATIVO
Real number (ℝ)
| Distinct | 42 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.968756 |
| Minimum | 1 |
|---|---|
| Maximum | 42 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 13 |
| Q3 | 27 |
| 95-th percentile | 39 |
| Maximum | 42 |
| Range | 41 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 12.449125 |
|---|---|
| Coefficient of variation (CV) | 0.73364982 |
| Kurtosis | -1.1287235 |
| Mean | 16.968756 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.49296737 |
| Sum | 5825323 |
| Variance | 154.98071 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 44561 | 13.0% |
| 6 | 27025 | 7.9% |
| 4 | 12094 | 3.5% |
| 2 | 10753 | 3.1% |
| 1 | 10155 | 3.0% |
| 8 | 9924 | 2.9% |
| 12 | 9707 | 2.8% |
| 3 | 9217 | 2.7% |
| 10 | 8632 | 2.5% |
| 7 | 8473 | 2.5% |
| Other values (32) | 192756 |
| Value | Count | Frequency (%) |
| 1 | 10155 | 3.0% |
| 2 | 10753 | 3.1% |
| 3 | 9217 | 2.7% |
| 4 | 12094 | 3.5% |
| 5 | 44561 | |
| 6 | 27025 | |
| 7 | 8473 | 2.5% |
| 8 | 9924 | 2.9% |
| 9 | 8298 | 2.4% |
| 10 | 8632 | 2.5% |
| Value | Count | Frequency (%) |
| 42 | 5669 | |
| 41 | 4271 | |
| 40 | 6478 | |
| 39 | 5386 | |
| 38 | 5524 | |
| 37 | 5034 | |
| 36 | 5557 | |
| 35 | 6452 | |
| 34 | 6249 | |
| 33 | 6275 |
PRAZO_FINANCIAMENTO
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| 120 | |
|---|---|
| 60 | |
| 240 | |
| 36 | 10639 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.6462975 |
| Min length | 2 |
Characters and Unicode
| Total characters | 908466 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 120 |
|---|---|
| 2nd row | 120 |
| 3rd row | 120 |
| 4th row | 120 |
| 5th row | 120 |
Common Values
| Value | Count | Frequency (%) |
| 120 | 184412 | |
| 60 | 110786 | |
| 240 | 37460 | 10.9% |
| 36 | 10639 | 3.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 120 | 184412 | |
| 60 | 110786 | |
| 240 | 37460 | 10.9% |
| 36 | 10639 | 3.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 332658 | |
| 2 | 221872 | |
| 1 | 184412 | |
| 6 | 121425 | 13.4% |
| 4 | 37460 | 4.1% |
| 3 | 10639 | 1.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 908466 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 332658 | |
| 2 | 221872 | |
| 1 | 184412 | |
| 6 | 121425 | 13.4% |
| 4 | 37460 | 4.1% |
| 3 | 10639 | 1.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 908466 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 332658 | |
| 2 | 221872 | |
| 1 | 184412 | |
| 6 | 121425 | 13.4% |
| 4 | 37460 | 4.1% |
| 3 | 10639 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 908466 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 332658 | |
| 2 | 221872 | |
| 1 | 184412 | |
| 6 | 121425 | 13.4% |
| 4 | 37460 | 4.1% |
| 3 | 10639 | 1.2% |
VALOR_TABELA
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| 80000 | |
|---|---|
| 300000 | |
| 20000 | |
| 230000 | 7156 |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.1620521 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1772117 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 20000 |
|---|---|
| 2nd row | 80000 |
| 3rd row | 230000 |
| 4th row | 80000 |
| 5th row | 80000 |
Common Values
| Value | Count | Frequency (%) |
| 80000 | 245218 | |
| 300000 | 48476 | 14.1% |
| 20000 | 42447 | 12.4% |
| 230000 | 7156 | 2.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 80000 | 245218 | |
| 300000 | 48476 | 14.1% |
| 20000 | 42447 | 12.4% |
| 230000 | 7156 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1421664 | |
| 8 | 245218 | 13.8% |
| 3 | 55632 | 3.1% |
| 2 | 49603 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1772117 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1421664 | |
| 8 | 245218 | 13.8% |
| 3 | 55632 | 3.1% |
| 2 | 49603 | 2.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1772117 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1421664 | |
| 8 | 245218 | 13.8% |
| 3 | 55632 | 3.1% |
| 2 | 49603 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1772117 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1421664 | |
| 8 | 245218 | 13.8% |
| 3 | 55632 | 3.1% |
| 2 | 49603 | 2.8% |
IDADE_CLIENTE
Real number (ℝ)
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 12 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.330673 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 23 |
| Q1 | 31 |
| median | 39 |
| Q3 | 48 |
| 95-th percentile | 63 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 12.511816 |
|---|---|
| Coefficient of variation (CV) | 0.31023078 |
| Kurtosis | -0.10701299 |
| Mean | 40.330673 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.59397818 |
| Sum | 13844915 |
| Variance | 156.54554 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33 | 11541 | 3.4% |
| 36 | 11416 | 3.3% |
| 34 | 11328 | 3.3% |
| 39 | 11200 | 3.3% |
| 37 | 11104 | 3.2% |
| 35 | 11049 | 3.2% |
| 38 | 11039 | 3.2% |
| 32 | 10933 | 3.2% |
| 31 | 10724 | 3.1% |
| 40 | 10341 | 3.0% |
| Other values (89) | 232610 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 2 | < 0.1% |
| 2 | 4 | < 0.1% |
| 3 | 6 | |
| 4 | 3 | < 0.1% |
| 5 | 7 | |
| 6 | 6 | |
| 7 | 14 | |
| 8 | 14 | |
| 9 | 7 |
| Value | Count | Frequency (%) |
| 100 | 1 | < 0.1% |
| 99 | 1 | < 0.1% |
| 96 | 1 | < 0.1% |
| 95 | 3 | < 0.1% |
| 94 | 1 | < 0.1% |
| 93 | 3 | < 0.1% |
| 92 | 6 | |
| 91 | 13 | |
| 90 | 9 | |
| 89 | 10 |
PRODUTO
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| AUTOMOVEIS | |
|---|---|
| IMOVEIS | |
| MOTOCICLETAS | |
| CAMINHÕES | 7156 |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 9.8028238 |
| Min length | 7 |
Characters and Unicode
| Total characters | 3365280 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MOTOCICLETAS |
|---|---|
| 2nd row | AUTOMOVEIS |
| 3rd row | CAMINHÕES |
| 4th row | AUTOMOVEIS |
| 5th row | AUTOMOVEIS |
Common Values
| Value | Count | Frequency (%) |
| AUTOMOVEIS | 245218 | |
| IMOVEIS | 48476 | 14.1% |
| MOTOCICLETAS | 42447 | 12.4% |
| CAMINHÕES | 7156 | 2.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| automoveis | 245218 | |
| imoveis | 48476 | 14.1% |
| motocicletas | 42447 | 12.4% |
| caminhões | 7156 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 623806 | |
| I | 391773 | |
| M | 343297 | |
| E | 343297 | |
| S | 343297 | |
| T | 330112 | |
| A | 294821 | |
| V | 293694 | |
| U | 245218 | 7.3% |
| C | 92050 | 2.7% |
| Other values (4) | 63915 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3365280 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 623806 | |
| I | 391773 | |
| M | 343297 | |
| E | 343297 | |
| S | 343297 | |
| T | 330112 | |
| A | 294821 | |
| V | 293694 | |
| U | 245218 | 7.3% |
| C | 92050 | 2.7% |
| Other values (4) | 63915 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3365280 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 623806 | |
| I | 391773 | |
| M | 343297 | |
| E | 343297 | |
| S | 343297 | |
| T | 330112 | |
| A | 294821 | |
| V | 293694 | |
| U | 245218 | 7.3% |
| C | 92050 | 2.7% |
| Other values (4) | 63915 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3358124 | |
| None | 7156 | 0.2% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 623806 | |
| I | 391773 | |
| M | 343297 | |
| E | 343297 | |
| S | 343297 | |
| T | 330112 | |
| A | 294821 | |
| V | 293694 | |
| U | 245218 | 7.3% |
| C | 92050 | 2.7% |
| Other values (3) | 56759 | 1.7% |
None
| Value | Count | Frequency (%) |
| Õ | 7156 |
QT_PC_PAGAS
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.0904319 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 2956 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 5 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.409509 |
|---|---|
| Coefficient of variation (CV) | 0.34458684 |
| Kurtosis | 137.26844 |
| Mean | 4.0904319 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.5708844 |
| Sum | 1404233 |
| Variance | 1.9867157 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 172598 | |
| 4 | 59290 | 17.3% |
| 3 | 43081 | 12.5% |
| 2 | 25275 | 7.4% |
| 1 | 23582 | 6.9% |
| 6 | 16036 | 4.7% |
| 0 | 2956 | 0.9% |
| 7 | 240 | 0.1% |
| 8 | 90 | < 0.1% |
| 9 | 51 | < 0.1% |
| Other values (21) | 98 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 2956 | 0.9% |
| 1 | 23582 | 6.9% |
| 2 | 25275 | 7.4% |
| 3 | 43081 | 12.5% |
| 4 | 59290 | 17.3% |
| 5 | 172598 | |
| 6 | 16036 | 4.7% |
| 7 | 240 | 0.1% |
| 8 | 90 | < 0.1% |
| 9 | 51 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 1 | |
| 80 | 1 | |
| 79 | 1 | |
| 75 | 1 | |
| 50 | 1 | |
| 47 | 1 | |
| 38 | 1 | |
| 34 | 1 | |
| 29 | 2 | |
| 24 | 1 |
QT_PC_VENCIDAS
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7926431 |
| Minimum | 0 |
|---|---|
| Maximum | 11 |
| Zeros | 241626 |
| Zeros (%) | 70.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.3372647 |
|---|---|
| Coefficient of variation (CV) | 1.6870956 |
| Kurtosis | 0.65382557 |
| Mean | 0.7926431 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.403196 |
| Sum | 272112 |
| Variance | 1.7882769 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 241626 | |
| 3 | 38096 | 11.1% |
| 2 | 30123 | 8.8% |
| 4 | 18656 | 5.4% |
| 1 | 12931 | 3.8% |
| 5 | 1373 | 0.4% |
| 6 | 317 | 0.1% |
| 7 | 157 | < 0.1% |
| 8 | 9 | < 0.1% |
| 9 | 6 | < 0.1% |
| Other values (2) | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 241626 | |
| 1 | 12931 | 3.8% |
| 2 | 30123 | 8.8% |
| 3 | 38096 | 11.1% |
| 4 | 18656 | 5.4% |
| 5 | 1373 | 0.4% |
| 6 | 317 | 0.1% |
| 7 | 157 | < 0.1% |
| 8 | 9 | < 0.1% |
| 9 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 11 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 9 | 6 | < 0.1% |
| 8 | 9 | < 0.1% |
| 7 | 157 | < 0.1% |
| 6 | 317 | 0.1% |
| 5 | 1373 | 0.4% |
| 4 | 18656 | |
| 3 | 38096 | |
| 2 | 30123 |
QT_PC_PAGA_ATRASO
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5791108 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 218566 |
| Zeros (%) | 63.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.91105301 |
|---|---|
| Coefficient of variation (CV) | 1.5731929 |
| Kurtosis | 2.3793899 |
| Mean | 0.5791108 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.6610949 |
| Sum | 198807 |
| Variance | 0.83001759 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 218566 | |
| 1 | 72422 | 21.1% |
| 2 | 34986 | 10.2% |
| 3 | 13198 | 3.8% |
| 4 | 3833 | 1.1% |
| 5 | 265 | 0.1% |
| 6 | 27 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 218566 | |
| 1 | 72422 | 21.1% |
| 2 | 34986 | 10.2% |
| 3 | 13198 | 3.8% |
| 4 | 3833 | 1.1% |
| 5 | 265 | 0.1% |
| 6 | 27 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 27 | < 0.1% |
| 5 | 265 | 0.1% |
| 4 | 3833 | 1.1% |
| 3 | 13198 | 3.8% |
| 2 | 34986 | 10.2% |
| 1 | 72422 | 21.1% |
| 0 | 218566 |
QT_PC_PAGA_EM_DIA
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5113211 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 3716 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 5 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.5449813 |
|---|---|
| Coefficient of variation (CV) | 0.43999999 |
| Kurtosis | 92.820075 |
| Mean | 3.5113211 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.4939897 |
| Sum | 1205426 |
| Variance | 2.3869671 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 107678 | |
| 4 | 75434 | |
| 3 | 53447 | |
| 2 | 46531 | |
| 1 | 45711 | |
| 6 | 10340 | 3.0% |
| 0 | 3716 | 1.1% |
| 7 | 220 | 0.1% |
| 8 | 80 | < 0.1% |
| 9 | 46 | < 0.1% |
| Other values (20) | 94 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 3716 | 1.1% |
| 1 | 45711 | |
| 2 | 46531 | |
| 3 | 53447 | |
| 4 | 75434 | |
| 5 | 107678 | |
| 6 | 10340 | 3.0% |
| 7 | 220 | 0.1% |
| 8 | 80 | < 0.1% |
| 9 | 46 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 1 | |
| 79 | 1 | |
| 77 | 1 | |
| 74 | 1 | |
| 48 | 1 | |
| 47 | 1 | |
| 38 | 1 | |
| 30 | 1 | |
| 29 | 1 | |
| 25 | 1 |
VALOR_PARCELAS_ATRASO
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 62 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 711.30849 |
| Minimum | 0 |
|---|---|
| Maximum | 41667 |
| Zeros | 241626 |
| Zeros (%) | 70.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1250 |
| 95-th percentile | 3750 |
| Maximum | 41667 |
| Range | 41667 |
| Interquartile range (IQR) | 1250 |
Descriptive statistics
| Standard deviation | 1435.8407 |
|---|---|
| Coefficient of variation (CV) | 2.0185907 |
| Kurtosis | 44.290591 |
| Mean | 711.30849 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.121667 |
| Sum | 2.4419007 × 108 |
| Variance | 2061638.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 241626 | |
| 2000 | 24899 | 7.3% |
| 2667 | 18436 | 5.4% |
| 1333 | 16684 | 4.9% |
| 667 | 8668 | 2.5% |
| 4000 | 6205 | 1.8% |
| 2500 | 5561 | 1.6% |
| 3750 | 3182 | 0.9% |
| 5000 | 3074 | 0.9% |
| 5333 | 2400 | 0.7% |
| Other values (52) | 12562 | 3.7% |
| Value | Count | Frequency (%) |
| 0 | 241626 | |
| 167 | 396 | 0.1% |
| 333 | 1878 | 0.5% |
| 500 | 735 | 0.2% |
| 556 | 110 | < 0.1% |
| 667 | 8668 | 2.5% |
| 833 | 29 | < 0.1% |
| 1000 | 1840 | 0.5% |
| 1111 | 314 | 0.1% |
| 1167 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 41667 | 1 | < 0.1% |
| 35000 | 3 | < 0.1% |
| 33333 | 24 | |
| 30000 | 2 | < 0.1% |
| 27500 | 1 | < 0.1% |
| 25000 | 25 | |
| 22500 | 2 | < 0.1% |
| 20000 | 31 | |
| 17500 | 18 | < 0.1% |
| 16667 | 46 |
| ID_CLIENTE | DIAS_ATIVO | MESES_ATIVO | IDADE_CLIENTE | QT_PC_PAGAS | QT_PC_VENCIDAS | QT_PC_PAGA_ATRASO | QT_PC_PAGA_EM_DIA | VALOR_PARCELAS_ATRASO | PRAZO_FINANCIAMENTO | VALOR_TABELA | PRODUTO | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID_CLIENTE | 1.000 | -0.301 | -0.307 | -0.005 | -0.070 | 0.182 | 0.207 | -0.212 | 0.156 | 0.238 | 0.176 | 0.176 |
| DIAS_ATIVO | -0.301 | 1.000 | 0.997 | 0.034 | 0.604 | -0.751 | 0.079 | 0.500 | -0.747 | 0.116 | 0.064 | 0.064 |
| MESES_ATIVO | -0.307 | 0.997 | 1.000 | 0.034 | 0.602 | -0.753 | 0.075 | 0.500 | -0.748 | 0.119 | 0.069 | 0.069 |
| IDADE_CLIENTE | -0.005 | 0.034 | 0.034 | 1.000 | 0.009 | -0.021 | -0.006 | 0.018 | -0.015 | 0.044 | 0.074 | 0.074 |
| QT_PC_PAGAS | -0.070 | 0.604 | 0.602 | 0.009 | 1.000 | -0.790 | 0.117 | 0.784 | -0.776 | 0.005 | 0.003 | 0.003 |
| QT_PC_VENCIDAS | 0.182 | -0.751 | -0.753 | -0.021 | -0.790 | 1.000 | -0.099 | -0.654 | 0.985 | 0.104 | 0.074 | 0.074 |
| QT_PC_PAGA_ATRASO | 0.207 | 0.079 | 0.075 | -0.006 | 0.117 | -0.099 | 1.000 | -0.460 | -0.098 | 0.081 | 0.104 | 0.104 |
| QT_PC_PAGA_EM_DIA | -0.212 | 0.500 | 0.500 | 0.018 | 0.784 | -0.654 | -0.460 | 1.000 | -0.637 | 0.006 | 0.001 | 0.001 |
| VALOR_PARCELAS_ATRASO | 0.156 | -0.747 | -0.748 | -0.015 | -0.776 | 0.985 | -0.098 | -0.637 | 1.000 | 0.069 | 0.118 | 0.118 |
| PRAZO_FINANCIAMENTO | 0.238 | 0.116 | 0.119 | 0.044 | 0.005 | 0.104 | 0.081 | 0.006 | 0.069 | 1.000 | 0.547 | 0.547 |
| VALOR_TABELA | 0.176 | 0.064 | 0.069 | 0.074 | 0.003 | 0.074 | 0.104 | 0.001 | 0.118 | 0.547 | 1.000 | 1.000 |
| PRODUTO | 0.176 | 0.064 | 0.069 | 0.074 | 0.003 | 0.074 | 0.104 | 0.001 | 0.118 | 0.547 | 1.000 | 1.000 |
| ID_CLIENTE | DATA_AQUISICAO | DIAS_ATIVO | MESES_ATIVO | PRAZO_FINANCIAMENTO | VALOR_TABELA | IDADE_CLIENTE | PRODUTO | QT_PC_PAGAS | QT_PC_VENCIDAS | QT_PC_PAGA_ATRASO | QT_PC_PAGA_EM_DIA | VALOR_PARCELAS_ATRASO | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 66221 | 18/06/2021 | 33 | 1 | 120 | 20000 | 42.0 | MOTOCICLETAS | 1 | 4 | 0 | 1 | 667 |
| 1 | 46982 | 10/04/2018 | 1198 | 39 | 120 | 80000 | 38.0 | AUTOMOVEIS | 5 | 0 | 1 | 4 | 0 |
| 2 | 57888 | 09/10/2020 | 285 | 9 | 120 | 230000 | 75.0 | CAMINHÕES | 5 | 0 | 3 | 2 | 0 |
| 3 | 51915 | 25/06/2019 | 757 | 25 | 120 | 80000 | 43.0 | AUTOMOVEIS | 5 | 0 | 1 | 4 | 0 |
| 4 | 52724 | 19/09/2019 | 671 | 22 | 120 | 80000 | 66.0 | AUTOMOVEIS | 5 | 0 | 5 | 0 | 0 |
| 5 | 46665 | 23/03/2018 | 1216 | 40 | 120 | 80000 | 41.0 | AUTOMOVEIS | 5 | 0 | 0 | 5 | 0 |
| 6 | 50275 | 04/02/2019 | 898 | 29 | 240 | 300000 | 45.0 | IMOVEIS | 1 | 0 | 0 | 1 | 0 |
| 7 | 58359 | 11/11/2020 | 252 | 8 | 120 | 80000 | 47.0 | AUTOMOVEIS | 5 | 0 | 2 | 3 | 0 |
| 8 | 48123 | 31/07/2018 | 1086 | 36 | 120 | 230000 | 41.0 | CAMINHÕES | 4 | 0 | 2 | 2 | 0 |
| 9 | 65114 | 03/05/2021 | 79 | 2 | 120 | 80000 | 42.0 | AUTOMOVEIS | 2 | 3 | 1 | 1 | 2000 |
| ID_CLIENTE | DATA_AQUISICAO | DIAS_ATIVO | MESES_ATIVO | PRAZO_FINANCIAMENTO | VALOR_TABELA | IDADE_CLIENTE | PRODUTO | QT_PC_PAGAS | QT_PC_VENCIDAS | QT_PC_PAGA_ATRASO | QT_PC_PAGA_EM_DIA | VALOR_PARCELAS_ATRASO | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 343287 | 27961680 | 04/04/2016 | 171 | 5 | 120 | 80000 | 49.0 | AUTOMOVEIS | 3 | 3 | 0 | 3 | 2000 |
| 343288 | 29574750 | 10/05/2018 | 174 | 5 | 120 | 80000 | 44.0 | AUTOMOVEIS | 3 | 3 | 2 | 1 | 2000 |
| 343289 | 571060681 | 03/11/2020 | 170 | 5 | 120 | 80000 | 56.0 | AUTOMOVEIS | 1 | 4 | 0 | 1 | 2667 |
| 343290 | 28860520 | 22/05/2017 | 162 | 5 | 120 | 80000 | 49.0 | AUTOMOVEIS | 3 | 3 | 0 | 3 | 2000 |
| 343291 | 27173320 | 28/04/2015 | 176 | 6 | 120 | 80000 | 66.0 | AUTOMOVEIS | 3 | 3 | 0 | 3 | 2000 |
| 343292 | 29393160 | 26/01/2018 | 166 | 6 | 120 | 80000 | 40.0 | AUTOMOVEIS | 2 | 4 | 0 | 2 | 2667 |
| 343293 | 25093062 | 15/04/2016 | 176 | 6 | 60 | 80000 | 46.0 | AUTOMOVEIS | 2 | 4 | 1 | 1 | 5333 |
| 343294 | 31101650 | 30/09/2019 | 163 | 6 | 60 | 80000 | 29.0 | AUTOMOVEIS | 2 | 3 | 0 | 2 | 4000 |
| 343295 | 26930480 | 16/01/2015 | 165 | 5 | 120 | 80000 | 62.0 | AUTOMOVEIS | 3 | 3 | 0 | 3 | 2000 |
| 343296 | 27876161 | 29/04/2016 | 154 | 5 | 120 | 80000 | 25.0 | AUTOMOVEIS | 3 | 3 | 1 | 2 | 2000 |